select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Gorgeous Rhinestone Wedding Tiara Jewelry Set With Necklace and Earrings
Alloy With Imitation Pearl Ladies Jewelry Sets
Butterfuly Rhinestone and Pearl Necklace Headpiece Wedding Jewelry Set
Blue Flowers Rhinestone Jewelry Set Including Necklace And Earrings
Dreamlike Rhinestones Alloy Necklace And Earrings Jewelry Set
Unique Alloy With Rhinestone Women Jewelry Sets
Fashion Nacklace and Headpiece Jewelry Sets in Round Shape
Unique Meshed Necklace And Earrings Jewelry Set Made by Crystal
Bowknot Pearl and Rhinestone Necklace Earring Jewelry Set
Princess Rhinestone Jewelry Set Including Necklace Tiara And Earrings
Gorgeous Alloy/Rhinestones Womens Jewelry Sets
Lovely Bowknot and Butterfly Necklace And Earrings Jewelry Set
Red Crystal Wedding Jewelry Set With Necklace and Feather Headpiece
Vintage Style Rhinestone Alloy Jewelry Set Including Crown Necklace And Earrings
Dignified Jewelry Set Including Necklace And Tiara
Graceful Purple Rhinestone Necklace And Earrings Wedding Jewelry Set
Rhinestone Wedding Jewelry Set Including Necklace Earrings And Crown With Bowknot
Imitation Pearl Jewelry Set Including Necklace And Tiara
Rhinestone Wedding Jewelry Set In Alloy Including Necklace Earrings And Crown
Imitation Pearl Jewelry Set Including Necklace And Tiara
Pearl Wedding Jewelry Set Including Necklace Earrings And Crown
Dreamlike Rhinestone Dignified Necklace
Flower Shape Rhinestone Jewelry Set Including Necklace Earrings And Earrings
Red Rhinestone Wedding Jewelry Set Including Necklace Crown And Earrings
Dignified Jewelry Set Including Necklace And Tiara
Unique Alloy With Rhinestone Ladies Jewelry Sets
Alloy Wedding Jewelry Set Including Necklace And Earrings in Silver
Imitation Pearl Alloy Jewelry Sets Including Necklace and Earings
Artistic Alloy Rhinestone Jewelry Set Including Necklace Earring And Crown
Elegant Alloy With Rhinestone Crystal Ladies Jewelry Sets